SCM - Laxman-Damodhier - 2016-07-13 - 27620 - Spec - Concur Travel & Expense Management (Babu by 2017-03-31) #docincom

SPECIFICATIONS

27620 - Spec - Concur Travel & Expense Management


Purpose


Concur Travel & Expense Management

Admin Info


Purpose
Concur Travel & Expense Management
Requested By
Babu Lankipalli
Spec Created By
Laxman
Spec Created Date
09/01/2016
Spec QA by
Laxman
Objects

Document Status
WIP


Estimates



Sl.No
Activity
Estimation in Hours
1
Research

2
Documentation
06
3
Development/ Config
76
4
Unit test in DEV
12
5
Unit test in QUA

6
Other activity


TOTAL
94

References


Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]



Documents

[Attach any document(s) received for the requirement(s)]




Spec Changes


[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
Change Details
Requested By
Requested On
Notes if any
01
Simplified the 350 file
Babu Lankipalli
11/21/2016





















Functional Requirement


Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

To implement the Concur for calculation of travel expenses, information of employees (who will travel) are required from SAP.

In Scope:

[List the activities to be included in scope]

Out of Scope:

[Out of scope activities]

Solution Summary


[Discuss this section with Requester and get approval prior to beginning work]

As a part of Concur implementation required employees (who will travel) information from SAP. For this decided to create the employee (who will travel) as a vendor. Then this vendor information will be send to Concur in two files for further processing. Files are given below for more details.

1. Need to extract only Z003 account group vendor information only.
2. For internal orders only consider of order type ZNEC


Standard_Accounting_Extract_v3.pdf

ERA_SAE Header Template with examples.xlsx


Employee_Import.pdf


Employee Import Example File.txt


ERA_305 Employee Import.xlsx


Currencies and Country Codes.xlsx

Files with Vendor data/ fields

ERA_305 Employee Import.xlsx


ERA_305 Employee Import Formatted_Dam.xls

ERA_SAE Header Template Formatted.xls


DT: 11/21/2016

To simplify the extraction process modified the file 350. Accordingly extraction file 350 should be modified.
Modified file format is given below.

ERA_350 Employee Import (2)_Modified.xlsx



Test Plan

[List test scenarios/cases to be executed here]
Test ID
Test Scenario
Expected Results
MM001
Create vendors using Z003 and internal orders of type ZNEC
then extract the file 305 and check
File should be correct (both values and format)
MM002
Create vendors using Z003 and internal orders of type ZNEC
then extract the file 350 and check
File should be correct (both values and format)

Solution Details


[Provide complete technical details for configuration or programming here]

Create the programs to extract both vendor import files 305 and 350.

Issues


[List Issues / Bugs identified in configuration or development]